package com.example.crt_dispatching_center.mapper;

import com.example.crt_dispatching_center.entity.Fare;
import com.example.crt_dispatching_center.entity.FlowDaily;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.util.List;

@Mapper
public interface FareMapper {
    @Select("SELECT * FROM fare_income WHERE date BETWEEN #{startDate} AND #{endDate}")
    List<Fare> findByDateBetween(LocalDate startDate, LocalDate endDate);
}
